USE [vudu]
GO
/****** Object:  StoredProcedure [dbo].[EliminarPensum]    Script Date: 01/29/2012 13:54:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[EliminarPrelacion]

	@idPensum int,
	@idMateria int,
	@idPrelacion int
AS
BEGIN

	SET NOCOUNT ON;
	DELETE FROM Prelacion WHERE fk_pensum = @idPensum 
	AND fk_materia_actual = @idMateria
	AND fk_materia_prelacion = @idPrelacion;
END